My Data Report

Brought to you by YData

Dataset statistics

Number of variables	15
Number of observations	548535
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	375.1 MiB
Average record size in memory	717.0 B

Variable types

Numeric	5
Text	6
Categorical	4

Alerts

`body` is highly overall correlated with `transmission`	High correlation
`color` is highly overall correlated with `transmission`	High correlation
`mmr` is highly overall correlated with `odometer` and 2 other fields	High correlation
`odometer` is highly overall correlated with `mmr` and 2 other fields	High correlation
`sellingprice` is highly overall correlated with `mmr` and 2 other fields	High correlation
`transmission` is highly overall correlated with `body` and 1 other fields	High correlation
`year` is highly overall correlated with `mmr` and 2 other fields	High correlation
`body` is highly imbalanced (52.4%)	Imbalance
`transmission` is highly imbalanced (87.3%)	Imbalance
`interior` is highly imbalanced (50.5%)	Imbalance

Reproduction

Analysis started	2025-07-10 12:48:27.561058
Analysis finished	2025-07-10 12:49:11.320243
Duration	43.76 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

year
Real number (ℝ)

High correlation

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2010.1151

Minimum	1984
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1984
5-th percentile	2002
Q1	2008
median	2012
Q3	2013
95-th percentile	2014
Maximum	2015
Range	31
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.9091265
Coefficient of variation (CV)	0.0019447277
Kurtosis	0.97970829
Mean	2010.1151
Median Absolute Deviation (MAD)	2
Skewness	-1.1909475
Sum	1.1026185 × 10⁹
Variance	15.28127
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
2012	101380	18.5%
2013	98113	17.9%
2014	80574	14.7%
2011	48216	8.8%
2008	31055	5.7%
2007	29495	5.4%
2010	25986	4.7%
2006	25421	4.6%
2009	20411	3.7%
2005	20280	3.7%
Other values (21)	67604	12.3%

Value	Count	Frequency (%)
1984	1	< 0.1%
1985	2	< 0.1%
1986	2	< 0.1%
1987	1	< 0.1%
1989	6	< 0.1%
1990	45	< 0.1%
1991	65	< 0.1%
1992	123	< 0.1%
1993	177	< 0.1%
1994	358	0.1%

Value	Count	Frequency (%)
2015	9223	1.7%
2014	80574	14.7%
2013	98113	17.9%
2012	101380	18.5%
2011	48216	8.8%
2010	25986	4.7%
2009	20411	3.7%
2008	31055	5.7%
2007	29495	5.4%
2006	25421	4.6%

make
Text

Distinct	96
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	33.0 MiB

Length

Max length	13
Median length	11
Mean length	5.9952236
Min length	2

Characters and Unicode

Total characters	3288590
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	Kia
2nd row	Kia
3rd row	BMW
4th row	Volvo
5th row	BMW

Value	Count	Frequency (%)
ford	94001	17.1%
chevrolet	60587	11.0%
nissan	54017	9.8%
toyota	39966	7.3%
dodge	30956	5.6%
honda	27351	5.0%
hyundai	21837	4.0%
bmw	20793	3.8%
kia	18084	3.3%
chrysler	17485	3.2%
Other values (54)	165366	30.0%

Most occurring characters

Value	Count	Frequency (%)
o	328819	10.0%
e	300106	9.1%
a	235578	7.2%
r	230199	7.0%
d	215895	6.6%
n	186317	5.7%
i	184908	5.6%
s	178494	5.4%
t	128322	3.9%
l	116781	3.6%
Other values (39)	1183171	36.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3288590	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	328819	10.0%
e	300106	9.1%
a	235578	7.2%
r	230199	7.0%
d	215895	6.6%
n	186317	5.7%
i	184908	5.6%
s	178494	5.4%
t	128322	3.9%
l	116781	3.6%
Other values (39)	1183171	36.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3288590	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	328819	10.0%
e	300106	9.1%
a	235578	7.2%
r	230199	7.0%
d	215895	6.6%
n	186317	5.7%
i	184908	5.6%
s	178494	5.4%
t	128322	3.9%
l	116781	3.6%
Other values (39)	1183171	36.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3288590	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	328819	10.0%
e	300106	9.1%
a	235578	7.2%
r	230199	7.0%
d	215895	6.6%
n	186317	5.7%
i	184908	5.6%
s	178494	5.4%
t	128322	3.9%
l	116781	3.6%
Other values (39)	1183171	36.0%

model
Text

Distinct	851
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	33.4 MiB

Length

Max length	29
Median length	23
Mean length	6.7669192
Min length	1

Characters and Unicode

Total characters	3711892
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	53 ?
Unique (%)	< 0.1%

Sample

1st row	sorento
2nd row	sorento
3rd row	3 series
4th row	s60
5th row	6 series gran coupe

Value	Count	Frequency (%)
altima	19432	2.9%
series	15515	2.3%
grand	14928	2.2%
f-150	14527	2.2%
1500	14476	2.2%
fusion	13639	2.0%
camry	13515	2.0%
escape	12027	1.8%
focus	10463	1.6%
g	9333	1.4%
Other values (740)	531442	79.4%

Most occurring characters

Value	Count	Frequency (%)
a	426799	11.5%
e	331192	8.9%
r	309170	8.3%
s	253866	6.8%
o	206541	5.6%
c	199372	5.4%
n	188769	5.1%
i	184780	5.0%
t	173535	4.7%
l	153434	4.1%
Other values (30)	1284434	34.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3711892	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	426799	11.5%
e	331192	8.9%
r	309170	8.3%
s	253866	6.8%
o	206541	5.6%
c	199372	5.4%
n	188769	5.1%
i	184780	5.0%
t	173535	4.7%
l	153434	4.1%
Other values (30)	1284434	34.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3711892	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	426799	11.5%
e	331192	8.9%
r	309170	8.3%
s	253866	6.8%
o	206541	5.6%
c	199372	5.4%
n	188769	5.1%
i	184780	5.0%
t	173535	4.7%
l	153434	4.1%
Other values (30)	1284434	34.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3711892	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	426799	11.5%
e	331192	8.9%
r	309170	8.3%
s	253866	6.8%
o	206541	5.6%
c	199372	5.4%
n	188769	5.1%
i	184780	5.0%
t	173535	4.7%
l	153434	4.1%
Other values (30)	1284434	34.6%

trim
Text

Distinct	1963
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	32.3 MiB

Length

Max length	46
Median length	37
Mean length	4.736407
Min length	1

Characters and Unicode

Total characters	2598085
Distinct characters	72
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	241 ?
Unique (%)	< 0.1%

Sample

1st row	LX
2nd row	LX
3rd row	328i SULEV
4th row	T5
5th row	650i

Value	Count	Frequency (%)
base	56196	8.4%
se	48404	7.2%
s	30314	4.5%
lx	21394	3.2%
limited	20585	3.1%
lt	20263	3.0%
2.5	18864	2.8%
xlt	18797	2.8%
ls	17937	2.7%
sport	17625	2.6%
Other values (963)	402466	59.8%

Most occurring characters

Value	Count	Frequency (%)
L	215102	8.3%
S	206547	7.9%
e	155289	6.0%
i	135294	5.2%
E	127072	4.9%
	124311	4.8%
T	120964	4.7%
a	109025	4.2%
r	97936	3.8%
X	91570	3.5%
Other values (62)	1214975	46.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2598085	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
L	215102	8.3%
S	206547	7.9%
e	155289	6.0%
i	135294	5.2%
E	127072	4.9%
	124311	4.8%
T	120964	4.7%
a	109025	4.2%
r	97936	3.8%
X	91570	3.5%
Other values (62)	1214975	46.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2598085	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
L	215102	8.3%
S	206547	7.9%
e	155289	6.0%
i	135294	5.2%
E	127072	4.9%
	124311	4.8%
T	120964	4.7%
a	109025	4.2%
r	97936	3.8%
X	91570	3.5%
Other values (62)	1214975	46.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2598085	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
L	215102	8.3%
S	206547	7.9%
e	155289	6.0%
i	135294	5.2%
E	127072	4.9%
	124311	4.8%
T	120964	4.7%
a	109025	4.2%
r	97936	3.8%
X	91570	3.5%
Other values (62)	1214975	46.8%

body
Categorical

High correlation Imbalance

Distinct	46
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	32.6 MiB

sedan	244235
suv	143844
hatchback	26238
minivan	25529
coupe	17752
Other values (41)	90937

Length

Max length	23
Median length	5
Mean length	5.2778073
Min length	3

Characters and Unicode

Total characters	2895062
Distinct characters	29
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	suv
2nd row	suv
3rd row	sedan
4th row	sedan
5th row	sedan

Common Values

Value	Count	Frequency (%)
sedan	244235	44.5%
suv	143844	26.2%
hatchback	26238	4.8%
minivan	25529	4.7%
coupe	17752	3.2%
crew cab	16394	3.0%
wagon	16129	2.9%
convertible	10476	1.9%
supercrew	9033	1.6%
g sedan	7417	1.4%
Other values (36)	31488	5.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sedan	251652	42.4%
suv	143844	24.2%
cab	33137	5.6%
hatchback	26238	4.4%
minivan	25529	4.3%
coupe	19983	3.4%
crew	16394	2.8%
wagon	16180	2.7%
convertible	10933	1.8%
g	9333	1.6%
Other values (33)	40608	6.8%

Most occurring characters

Value	Count	Frequency (%)
s	415043	14.3%
a	401157	13.9%
e	360625	12.5%
n	341773	11.8%
d	266362	9.2%
u	189113	6.5%
v	186798	6.5%
c	148924	5.1%
b	77516	2.7%
i	64724	2.2%
Other values (19)	443027	15.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2895062	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	415043	14.3%
a	401157	13.9%
e	360625	12.5%
n	341773	11.8%
d	266362	9.2%
u	189113	6.5%
v	186798	6.5%
c	148924	5.1%
b	77516	2.7%
i	64724	2.2%
Other values (19)	443027	15.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2895062	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	415043	14.3%
a	401157	13.9%
e	360625	12.5%
n	341773	11.8%
d	266362	9.2%
u	189113	6.5%
v	186798	6.5%
c	148924	5.1%
b	77516	2.7%
i	64724	2.2%
Other values (19)	443027	15.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2895062	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	415043	14.3%
a	401157	13.9%
e	360625	12.5%
n	341773	11.8%
d	266362	9.2%
u	189113	6.5%
v	186798	6.5%
c	148924	5.1%
b	77516	2.7%
i	64724	2.2%
Other values (19)	443027	15.3%

transmission
Categorical

High correlation Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	34.5 MiB

automatic	531434
manual	17075
sedan	26

Length

Max length	9
Median length	9
Mean length	8.9064253
Min length	5

Characters and Unicode

Total characters	4885486
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	automatic
2nd row	automatic
3rd row	automatic
4th row	automatic
5th row	automatic

Common Values

Value	Count	Frequency (%)
automatic	531434	96.9%
manual	17075	3.1%
sedan	26	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
automatic	531434	96.9%
manual	17075	3.1%
sedan	26	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	1097044	22.5%
t	1062868	21.8%
u	548509	11.2%
m	548509	11.2%
o	531434	10.9%
i	531434	10.9%
c	531434	10.9%
n	17101	0.4%
l	17075	0.3%
s	26	< 0.1%
Other values (2)	52	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4885486	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1097044	22.5%
t	1062868	21.8%
u	548509	11.2%
m	548509	11.2%
o	531434	10.9%
i	531434	10.9%
c	531434	10.9%
n	17101	0.4%
l	17075	0.3%
s	26	< 0.1%
Other values (2)	52	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4885486	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1097044	22.5%
t	1062868	21.8%
u	548509	11.2%
m	548509	11.2%
o	531434	10.9%
i	531434	10.9%
c	531434	10.9%
n	17101	0.4%
l	17075	0.3%
s	26	< 0.1%
Other values (2)	52	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4885486	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1097044	22.5%
t	1062868	21.8%
u	548509	11.2%
m	548509	11.2%
o	531434	10.9%
i	531434	10.9%
c	531434	10.9%
n	17101	0.4%
l	17075	0.3%
s	26	< 0.1%
Other values (2)	52	< 0.1%

state
Text

Distinct	64
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	30.9 MiB

Length

Max length	17
Median length	2
Mean length	2.000711
Min length	2

Characters and Unicode

Total characters	1097460
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26 ?
Unique (%)	< 0.1%

Sample

1st row	ca
2nd row	ca
3rd row	ca
4th row	ca
5th row	ca

Value	Count	Frequency (%)
fl	81482	14.9%
ca	71667	13.1%
pa	53158	9.7%
tx	45196	8.2%
ga	34059	6.2%
nj	27365	5.0%
il	23196	4.2%
nc	21333	3.9%
oh	21252	3.9%
tn	20691	3.8%
Other values (54)	149136	27.2%

Most occurring characters

Value	Count	Frequency (%)
a	195954	17.9%
n	108197	9.9%
l	106867	9.7%
c	105915	9.7%
f	81508	7.4%
t	67685	6.2%
m	59757	5.4%
p	55831	5.1%
i	53682	4.9%
o	48924	4.5%
Other values (26)	213140	19.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1097460	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	195954	17.9%
n	108197	9.9%
l	106867	9.7%
c	105915	9.7%
f	81508	7.4%
t	67685	6.2%
m	59757	5.4%
p	55831	5.1%
i	53682	4.9%
o	48924	4.5%
Other values (26)	213140	19.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1097460	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	195954	17.9%
n	108197	9.9%
l	106867	9.7%
c	105915	9.7%
f	81508	7.4%
t	67685	6.2%
m	59757	5.4%
p	55831	5.1%
i	53682	4.9%
o	48924	4.5%
Other values (26)	213140	19.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1097460	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	195954	17.9%
n	108197	9.9%
l	106867	9.7%
c	105915	9.7%
f	81508	7.4%
t	67685	6.2%
m	59757	5.4%
p	55831	5.1%
i	53682	4.9%
o	48924	4.5%
Other values (26)	213140	19.4%

condition
Real number (ℝ)

Distinct	41
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.631234

Minimum	1
Maximum	49
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	23
median	34
Q3	41
95-th percentile	47
Maximum	49
Range	48
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	13.401857
Coefficient of variation (CV)	0.43752259
Kurtosis	-0.2304798
Mean	30.631234
Median Absolute Deviation (MAD)	8
Skewness	-0.82779016
Sum	16802304
Variance	179.60976
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
19	43050	7.8%
35	26808	4.9%
37	25902	4.7%
44	25463	4.6%
43	24925	4.5%
42	24333	4.4%
36	23174	4.2%
41	23038	4.2%
2	21108	3.8%
39	19937	3.6%
Other values (31)	290797	53.0%

Value	Count	Frequency (%)
1	7458	1.4%
2	21108	3.8%
3	10772	2.0%
4	19796	3.6%
5	11154	2.0%
11	91	< 0.1%
12	97	< 0.1%
13	79	< 0.1%
14	138	< 0.1%
15	144	< 0.1%

Value	Count	Frequency (%)
49	13038	2.4%
48	12686	2.3%
47	11346	2.1%
46	12616	2.3%
45	12273	2.2%
44	25463	4.6%
43	24925	4.5%
42	24333	4.4%
41	23038	4.2%
39	19937	3.6%

odometer
Real number (ℝ)

High correlation

Distinct	170099
Distinct (%)	31.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67533.923

Minimum	1
Maximum	999999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	10449
Q1	28133
median	51402
Q3	97926.5
95-th percentile	168655.2
Maximum	999999
Range	999998
Interquartile range (IQR)	69793.5

Descriptive statistics

Standard deviation	52917.195
Coefficient of variation (CV)	0.78356466
Kurtosis	13.803513
Mean	67533.923
Median Absolute Deviation (MAD)	29819
Skewness	1.8627155
Sum	3.7044721 × 10¹⁰
Variance	2.8002296 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1254	0.2%
999999	69	< 0.1%
10	29	< 0.1%
21587	21	< 0.1%
2	18	< 0.1%
29137	18	< 0.1%
21310	18	< 0.1%
8	18	< 0.1%
31258	17	< 0.1%
24023	17	< 0.1%
Other values (170089)	547056	99.7%

Value	Count	Frequency (%)
1	1254	0.2%
2	18	< 0.1%
3	9	< 0.1%
4	9	< 0.1%
5	17	< 0.1%
6	13	< 0.1%
7	13	< 0.1%
8	18	< 0.1%
9	11	< 0.1%
10	29	< 0.1%

Value	Count	Frequency (%)
999999	69	< 0.1%
980113	1	< 0.1%
959276	1	< 0.1%
694978	2	< 0.1%
621388	1	< 0.1%
580956	1	< 0.1%
537334	1	< 0.1%
522212	1	< 0.1%
500227	1	< 0.1%
495757	1	< 0.1%

color
Categorical

High correlation

Distinct	46
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	32.9 MiB

black	109300
white	104426
silver	81960
gray	81956
blue	50106
Other values (41)	120787

Length

Max length	9
Median length	8
Mean length	4.6244889
Min length	1

Characters and Unicode

Total characters	2536694
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26 ?
Unique (%)	< 0.1%

Sample

1st row	white
2nd row	white
3rd row	gray
4th row	white
5th row	gray

Common Values

Value	Count	Frequency (%)
black	109300	19.9%
white	104426	19.0%
silver	81960	14.9%
gray	81956	14.9%
blue	50106	9.1%
red	42811	7.8%
—	24592	4.5%
gold	11006	2.0%
green	10960	2.0%
beige	8998	1.6%
Other values (36)	22420	4.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
black	109300	19.9%
white	104426	19.0%
silver	81960	14.9%
gray	81956	14.9%
blue	50106	9.1%
red	42811	7.8%
—	24592	4.5%
gold	11006	2.0%
green	10960	2.0%
beige	8998	1.6%
Other values (36)	22420	4.1%

Most occurring characters

Value	Count	Frequency (%)
e	325652	12.8%
l	256860	10.1%
r	237366	9.4%
i	197087	7.8%
a	194211	7.7%
b	183850	7.2%
g	123735	4.9%
w	113724	4.5%
c	110246	4.3%
k	109342	4.3%
Other values (25)	684621	27.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2536694	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	325652	12.8%
l	256860	10.1%
r	237366	9.4%
i	197087	7.8%
a	194211	7.7%
b	183850	7.2%
g	123735	4.9%
w	113724	4.5%
c	110246	4.3%
k	109342	4.3%
Other values (25)	684621	27.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2536694	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	325652	12.8%
l	256860	10.1%
r	237366	9.4%
i	197087	7.8%
a	194211	7.7%
b	183850	7.2%
g	123735	4.9%
w	113724	4.5%
c	110246	4.3%
k	109342	4.3%
Other values (25)	684621	27.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2536694	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	325652	12.8%
l	256860	10.1%
r	237366	9.4%
i	197087	7.8%
a	194211	7.7%
b	183850	7.2%
g	123735	4.9%
w	113724	4.5%
c	110246	4.3%
k	109342	4.3%
Other values (25)	684621	27.0%

interior
Categorical

Imbalance

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	32.6 MiB

black	241298
gray	174741
beige	58679
tan	43162
—	16738
Other values (12)	13917

Length

Max length	9
Median length	5
Mean length	4.4020673
Min length	1

Characters and Unicode

Total characters	2414688
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	black
2nd row	beige
3rd row	black
4th row	black
5th row	black

Common Values

Value	Count	Frequency (%)
black	241298	44.0%
gray	174741	31.9%
beige	58679	10.7%
tan	43162	7.9%
—	16738	3.1%
brown	8474	1.5%
red	1329	0.2%
silver	1083	0.2%
blue	1070	0.2%
off-white	485	0.1%
Other values (7)	1476	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
black	241298	44.0%
gray	174741	31.9%
beige	58679	10.7%
tan	43162	7.9%
—	16738	3.1%
brown	8474	1.5%
red	1329	0.2%
silver	1083	0.2%
blue	1070	0.2%
off-white	485	0.1%
Other values (7)	1476	0.3%

Most occurring characters

Value	Count	Frequency (%)
a	459337	19.0%
b	309708	12.8%
l	244139	10.1%
c	241298	10.0%
k	241298	10.0%
g	234292	9.7%
r	186517	7.7%
y	174948	7.2%
e	122533	5.1%
i	60498	2.5%
Other values (13)	140120	5.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2414688	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	459337	19.0%
b	309708	12.8%
l	244139	10.1%
c	241298	10.0%
k	241298	10.0%
g	234292	9.7%
r	186517	7.7%
y	174948	7.2%
e	122533	5.1%
i	60498	2.5%
Other values (13)	140120	5.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2414688	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	459337	19.0%
b	309708	12.8%
l	244139	10.1%
c	241298	10.0%
k	241298	10.0%
g	234292	9.7%
r	186517	7.7%
y	174948	7.2%
e	122533	5.1%
i	60498	2.5%
Other values (13)	140120	5.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2414688	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	459337	19.0%
b	309708	12.8%
l	244139	10.1%
c	241298	10.0%
k	241298	10.0%
g	234292	9.7%
r	186517	7.7%
y	174948	7.2%
e	122533	5.1%
i	60498	2.5%
Other values (13)	140120	5.8%

seller
Text

Distinct	14084
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	41.8 MiB

Length

Max length	50
Median length	42
Mean length	22.996901
Min length	3

Characters and Unicode

Total characters	12614605
Distinct characters	47
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4888 ?
Unique (%)	0.9%

Sample

1st row	kia motors america inc
2nd row	kia motors america inc
3rd row	financial services remarketing (lease)
4th row	volvo na rep/world omni
5th row	financial services remarketing (lease)

Value	Count	Frequency (%)
inc	84687	4.6%
corporation	47535	2.6%
services	47406	2.6%
auto	46272	2.5%
credit	46249	2.5%
motor	45605	2.5%
llc	45067	2.4%
financial	43492	2.4%
ford	35890	1.9%
remarketing	34367	1.9%
Other values (8488)	1369096	74.2%

Most occurring characters

Value	Count	Frequency (%)
	1315618	10.4%
e	1123791	8.9%
a	1032357	8.2%
r	945141	7.5%
n	937696	7.4%
i	902124	7.2%
o	848435	6.7%
t	782371	6.2%
c	722194	5.7%
s	659071	5.2%
Other values (37)	3345807	26.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12614605	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1315618	10.4%
e	1123791	8.9%
a	1032357	8.2%
r	945141	7.5%
n	937696	7.4%
i	902124	7.2%
o	848435	6.7%
t	782371	6.2%
c	722194	5.7%
s	659071	5.2%
Other values (37)	3345807	26.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12614605	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1315618	10.4%
e	1123791	8.9%
a	1032357	8.2%
r	945141	7.5%
n	937696	7.4%
i	902124	7.2%
o	848435	6.7%
t	782371	6.2%
c	722194	5.7%
s	659071	5.2%
Other values (37)	3345807	26.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12614605	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1315618	10.4%
e	1123791	8.9%
a	1032357	8.2%
r	945141	7.5%
n	937696	7.4%
i	902124	7.2%
o	848435	6.7%
t	782371	6.2%
c	722194	5.7%
s	659071	5.2%
Other values (37)	3345807	26.5%

mmr
Real number (ℝ)

High correlation

Distinct	1102
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13857.926

Minimum	25
Maximum	182000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	25
5-th percentile	1850
Q1	7275
median	12350
Q3	18400
95-th percentile	30600
Maximum	182000
Range	181975
Interquartile range (IQR)	11125

Descriptive statistics

Standard deviation	9655.8055
Coefficient of variation (CV)	0.69677132
Kurtosis	11.657457
Mean	13857.926
Median Absolute Deviation (MAD)	5525
Skewness	2.0085911
Sum	7.6015575 × 10⁹
Variance	93234579
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12500	1748	0.3%
11600	1739	0.3%
11650	1734	0.3%
12150	1714	0.3%
11850	1707	0.3%
11300	1704	0.3%
11750	1692	0.3%
12350	1686	0.3%
12700	1683	0.3%
12200	1677	0.3%
Other values (1092)	531451	96.9%

Value	Count	Frequency (%)
25	27	< 0.1%
50	41	< 0.1%
75	22	< 0.1%
100	32	< 0.1%
125	34	< 0.1%
150	42	< 0.1%
175	63	< 0.1%
200	51	< 0.1%
225	56	< 0.1%
250	75	< 0.1%

Value	Count	Frequency (%)
182000	1	< 0.1%
178000	1	< 0.1%
176000	1	< 0.1%
172000	1	< 0.1%
170000	3	< 0.1%
166000	3	< 0.1%
164000	1	< 0.1%
163000	1	< 0.1%
162000	1	< 0.1%
161000	1	< 0.1%

sellingprice
Real number (ℝ)

High correlation

Distinct	1879
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13698.551

Minimum	1
Maximum	230000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1550
Q1	7000
median	12200
Q3	18300
95-th percentile	30600
Maximum	230000
Range	229999
Interquartile range (IQR)	11300

Descriptive statistics

Standard deviation	9728.1041
Coefficient of variation (CV)	0.71015573
Kurtosis	11.315799
Mean	13698.551
Median Absolute Deviation (MAD)	5600
Skewness	1.9641304
Sum	7.5141344 × 10⁹
Variance	94636010
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11000	4409	0.8%
12000	4395	0.8%
13000	4288	0.8%
10000	3994	0.7%
14000	3864	0.7%
11500	3839	0.7%
12500	3686	0.7%
9000	3622	0.7%
10500	3490	0.6%
15000	3358	0.6%
Other values (1869)	509590	92.9%

Value	Count	Frequency (%)
1	4	< 0.1%
100	17	< 0.1%
150	18	< 0.1%
175	10	< 0.1%
200	175	< 0.1%
225	93	< 0.1%
250	256	< 0.1%
275	110	< 0.1%
300	1168	0.2%
325	196	< 0.1%

Value	Count	Frequency (%)
230000	1	< 0.1%
183000	1	< 0.1%
173000	1	< 0.1%
171500	1	< 0.1%
169500	1	< 0.1%
169000	1	< 0.1%
167000	1	< 0.1%
165000	2	< 0.1%
163000	2	< 0.1%
161000	1	< 0.1%

saledate
Text

Distinct	3736
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	50.2 MiB

Length

Max length	39
Median length	39
Mean length	38.998379
Min length	4

Characters and Unicode

Total characters	21391976
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	600 ?
Unique (%)	0.1%

Sample

1st row	Tue Dec 16 2014 12:30:00 GMT-0800 (PST)
2nd row	Tue Dec 16 2014 12:30:00 GMT-0800 (PST)
3rd row	Thu Jan 15 2015 04:30:00 GMT-0800 (PST)
4th row	Thu Jan 29 2015 04:30:00 GMT-0800 (PST)
5th row	Thu Dec 18 2014 12:30:00 GMT-0800 (PST)

Value	Count	Frequency (%)
2015	494872	12.9%
pst	388481	10.1%
gmt-0800	388481	10.1%
wed	163323	4.3%
tue	160631	4.2%
gmt-0700	160028	4.2%
pdt	160028	4.2%
feb	159116	4.1%
thu	150756	3.9%
jan	138734	3.6%
Other values (332)	1475139	38.4%

Most occurring characters

Value	Count	Frequency (%)
0	4730233	22.1%
	3291054	15.4%
T	1408405	6.6%
:	1097018	5.1%
1	1042806	4.9%
2	944381	4.4%
M	660400	3.1%
5	646848	3.0%
)	548509	2.6%
G	548509	2.6%
Other values (30)	6473813	30.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21391976	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4730233	22.1%
	3291054	15.4%
T	1408405	6.6%
:	1097018	5.1%
1	1042806	4.9%
2	944381	4.4%
M	660400	3.1%
5	646848	3.0%
)	548509	2.6%
G	548509	2.6%
Other values (30)	6473813	30.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21391976	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4730233	22.1%
	3291054	15.4%
T	1408405	6.6%
:	1097018	5.1%
1	1042806	4.9%
2	944381	4.4%
M	660400	3.1%
5	646848	3.0%
)	548509	2.6%
G	548509	2.6%
Other values (30)	6473813	30.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21391976	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4730233	22.1%
	3291054	15.4%
T	1408405	6.6%
:	1097018	5.1%
1	1042806	4.9%
2	944381	4.4%
M	660400	3.1%
5	646848	3.0%
)	548509	2.6%
G	548509	2.6%
Other values (30)	6473813	30.3%

	body	color	condition	interior	mmr	odometer	sellingprice	transmission	year
body	1.000	0.156	0.061	0.076	0.146	0.065	0.126	0.725	0.083
color	0.156	1.000	0.056	0.102	0.055	0.065	0.048	0.709	0.090
condition	0.061	0.056	1.000	0.058	0.428	-0.405	0.480	0.022	0.391
interior	0.076	0.102	0.058	1.000	0.063	0.090	0.062	0.070	0.109
mmr	0.146	0.055	0.428	0.063	1.000	-0.714	0.979	0.020	0.692
odometer	0.065	0.065	-0.405	0.090	-0.714	1.000	-0.700	0.020	-0.815
sellingprice	0.126	0.048	0.480	0.062	0.979	-0.700	1.000	0.011	0.674
transmission	0.725	0.709	0.022	0.070	0.020	0.020	0.011	1.000	0.060
year	0.083	0.090	0.391	0.109	0.692	-0.815	0.674	0.060	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	year	make	model	trim	body	transmission	state	condition	odometer	color	interior	seller	mmr	sellingprice	saledate
0	2015	Kia	sorento	LX	suv	automatic	ca	5.0	16639.0	white	black	kia motors america inc	20500.0	21500.0	Tue Dec 16 2014 12:30:00 GMT-0800 (PST)
1	2015	Kia	sorento	LX	suv	automatic	ca	5.0	9393.0	white	beige	kia motors america inc	20800.0	21500.0	Tue Dec 16 2014 12:30:00 GMT-0800 (PST)
2	2014	BMW	3 series	328i SULEV	sedan	automatic	ca	45.0	1331.0	gray	black	financial services remarketing (lease)	31900.0	30000.0	Thu Jan 15 2015 04:30:00 GMT-0800 (PST)
3	2015	Volvo	s60	T5	sedan	automatic	ca	41.0	14282.0	white	black	volvo na rep/world omni	27500.0	27750.0	Thu Jan 29 2015 04:30:00 GMT-0800 (PST)
4	2014	BMW	6 series gran coupe	650i	sedan	automatic	ca	43.0	2641.0	gray	black	financial services remarketing (lease)	66000.0	67000.0	Thu Dec 18 2014 12:30:00 GMT-0800 (PST)
5	2015	Nissan	altima	2.5 S	sedan	automatic	ca	1.0	5554.0	gray	black	enterprise vehicle exchange / tra / rental / tulsa	15350.0	10900.0	Tue Dec 30 2014 12:00:00 GMT-0800 (PST)
6	2014	BMW	m5	Base	sedan	automatic	ca	34.0	14943.0	black	black	the hertz corporation	69000.0	65000.0	Wed Dec 17 2014 12:30:00 GMT-0800 (PST)
7	2014	Chevrolet	cruze	1LT	sedan	automatic	ca	2.0	28617.0	black	black	enterprise vehicle exchange / tra / rental / tulsa	11900.0	9800.0	Tue Dec 16 2014 13:00:00 GMT-0800 (PST)
8	2014	Audi	a4	2.0T Premium Plus quattro	sedan	automatic	ca	42.0	9557.0	white	black	audi mission viejo	32100.0	32250.0	Thu Dec 18 2014 12:00:00 GMT-0800 (PST)
9	2014	Chevrolet	camaro	LT	convertible	automatic	ca	3.0	4809.0	red	black	d/m auto sales inc	26300.0	17500.0	Tue Jan 20 2015 04:00:00 GMT-0800 (PST)

	year	make	model	trim	body	transmission	state	condition	odometer	color	interior	seller	mmr	sellingprice	saledate
548525	2014	Jeep	grand cherokee	Laredo	suv	automatic	pa	42.0	25180.0	gray	black	hertz corporation/gdp	26000.0	24500.0	Tue Jul 07 2015 06:30:00 GMT-0700 (PDT)
548526	2012	Dodge	grand caravan	American Value Package	minivan	automatic	ma	37.0	97036.0	silver	gray	ge fleet services for itself/servicer	8300.0	7800.0	Tue Jul 07 2015 06:30:00 GMT-0700 (PDT)
548527	2012	Hyundai	elantra	Limited	sedan	automatic	pa	4.0	66720.0	gray	gray	champion mazda	10250.0	10400.0	Wed Jul 08 2015 07:30:00 GMT-0700 (PDT)
548528	2012	Nissan	sentra	2.0 SR	sedan	automatic	tn	26.0	35858.0	white	gray	nissan-infiniti lt	9950.0	10400.0	Wed Jul 08 2015 17:15:00 GMT-0700 (PDT)
548529	2011	BMW	5 series	528i	sedan	automatic	fl	39.0	66403.0	white	brown	lauderdale imports ltd bmw pembrok pines	20300.0	22800.0	Tue Jul 07 2015 06:15:00 GMT-0700 (PDT)
548530	2015	Kia	k900	Luxury	sedan	automatic	in	45.0	18255.0	silver	black	avis corporation	35300.0	33000.0	Thu Jul 09 2015 07:00:00 GMT-0700 (PDT)
548531	2012	Ram	2500	Power Wagon	crew cab	automatic	wa	5.0	54393.0	white	black	i -5 uhlmann rv	30200.0	30800.0	Wed Jul 08 2015 09:30:00 GMT-0700 (PDT)
548532	2012	BMW	x5	xDrive35d	suv	automatic	ca	48.0	50561.0	black	black	financial services remarketing (lease)	29800.0	34000.0	Wed Jul 08 2015 09:30:00 GMT-0700 (PDT)
548533	2015	Nissan	altima	2.5 S	sedan	automatic	ga	38.0	16658.0	white	black	enterprise vehicle exchange / tra / rental / tulsa	15100.0	11100.0	Thu Jul 09 2015 06:45:00 GMT-0700 (PDT)
548534	2014	Ford	f-150	XLT	supercrew	automatic	ca	34.0	15008.0	gray	gray	ford motor credit company llc pd	29600.0	26700.0	Thu May 28 2015 05:30:00 GMT-0700 (PDT)

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values